RE: Tracing SQL
Hi, There's a typo in your driver package that is causing the driver not found error. Change: nl.gx.common.jcbc.DriverWrapper to nl.gx.common.jdbc.DriverWrapper It works nicely. Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of HyungKee Hwang Sent: Wednesday, May 30, 2001 9:13 PM To: Orion-Interest Subject: RE: Tracing SQL I downloaded and tried it, but I met the following error message, Error initializing server: DriverManagerDataSource driver 'nl.gx.common.jcbc.DriverWrapper' not found As I know, we don't have to do anything to include it in the classpath as long as it is located in c:/orion/lib, where c:/orion is orion home directory. Anyway, I included it in the classpath but the same error message came up. How can I fix the problem? BTW, the jdbc logger can be used against Oracle database? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 5:00 PM To: Orion-Interest Subject: RE: Tracing SQL You can find the jdbc logger at http://marcel.schutte.com/DriverWrapper.zip. It is certainly not a finished product, just some classes to get you on your way. Unzip in orion/lib. In data-sources.xml you have to use nl.gx.common.jcbc.DriverWrapper instead of your original database driver. Hope this helps, Marcel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 12:22 AM To: Orion-Interest Subject: Re: Tracing SQL That's right, I've got it at my daytime (work) PC. Look into it tomorrow morning (GMT+1). Right now I'm enjoying some winamp plugins and wine. Marcel - Original Message - From: Jeff Schnitzer [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:31 PM Subject: RE: Tracing SQL I don't believe there is any way to force Orion to spit out that information. However, when running against Hypersonic in server mode, you see all the SQL on the database console. I find this to be an excellent arrangement for development. If you wanted to, you could fairly easily write a JDBC wrapper that prints the SQL. I wouldn't be surprised if someone has already written such a creature. Jeff -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:03 PM To: Orion-Interest Subject: Tracing SQL Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life.
RE: Tracing SQL
Thank you and sorry for my mistake. But, I met another error message after fixing it. I'm using Oracle database. The error message is as follows; java.lang.NullPointerException at com.evermind.server.deployment.EnterpriseArchive.aj8(JAX) at com.evermind.server.deployment.EnterpriseArchive.bx(JAX) at com.evermind.xml.XMLConfig.bs(JAX) at com.evermind.xml.XMLConfig.ay(JAX) at com.evermind.xml.XMLConfig.ay(JAX) at com.evermind.server.ServerComponent.ay(JAX) at com.evermind.server.XMLApplicationServerConfig.aln(JAX) at com.evermind.server.XMLApplicationServerConfig.by(JAX) at com.evermind.xml.XMLConfig.ay(JAX) at com.evermind.xml.XMLConfig.ay(JAX) at com.evermind.server.hf.run(JAX) at java.lang.Thread.run(Unknown Source) at com.evermind.util.f.run(JAX) thank you in advance -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chuck Stern Sent: Thursday, May 31, 2001 8:32 PM To: Orion-Interest Subject: RE: Tracing SQL Hi, There's a typo in your driver package that is causing the driver not found error. Change: nl.gx.common.jcbc.DriverWrapper to nl.gx.common.jdbc.DriverWrapper It works nicely. Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of HyungKee Hwang Sent: Wednesday, May 30, 2001 9:13 PM To: Orion-Interest Subject: RE: Tracing SQL I downloaded and tried it, but I met the following error message, Error initializing server: DriverManagerDataSource driver 'nl.gx.common.jcbc.DriverWrapper' not found As I know, we don't have to do anything to include it in the classpath as long as it is located in c:/orion/lib, where c:/orion is orion home directory. Anyway, I included it in the classpath but the same error message came up. How can I fix the problem? BTW, the jdbc logger can be used against Oracle database? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 5:00 PM To: Orion-Interest Subject: RE: Tracing SQL You can find the jdbc logger at http://marcel.schutte.com/DriverWrapper.zip. It is certainly not a finished product, just some classes to get you on your way. Unzip in orion/lib. In data-sources.xml you have to use nl.gx.common.jcbc.DriverWrapper instead of your original database driver. Hope this helps, Marcel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 12:22 AM To: Orion-Interest Subject: Re: Tracing SQL That's right, I've got it at my daytime (work) PC. Look into it tomorrow morning (GMT+1). Right now I'm enjoying some winamp plugins and wine. Marcel - Original Message - From: Jeff Schnitzer [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:31 PM Subject: RE: Tracing SQL I don't believe there is any way to force Orion to spit out that information. However, when running against Hypersonic in server mode, you see all the SQL on the database console. I find this to be an excellent arrangement for development. If you wanted to, you could fairly easily write a JDBC wrapper that prints the SQL. I wouldn't be surprised if someone has already written such a creature. Jeff -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:03 PM To: Orion-Interest Subject: Tracing SQL Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life.
RE: Tracing SQL
Dear Josh, Thanks for the info. Kees Jan You are only young once, but you can stay immature all your life. -Original Message- From: Josh P. Motto [mailto:[EMAIL PROTECTED]] Sent: dinsdag 29 mei 2001 22:38 To: Orion-Interest Subject: Re: Tracing SQL Here is the JDBC debugging calls for Orion... just put them in your orion start statement using -D... for example java -Ddatasource.verbose -Djdbc.debug -jar orion.jar Property nameDescription datasource.verbose Setting this to true gives you verbose info on datasource-creation. When a new datasource is created (at startup) it will print something like this to the console: jdbc:HypersonicSQL:defaultdb: Started or Orion Pooled jdbc:oracle:thin:@test.foo.com:1521:oracle8i: Started. You will also be notified when connections are opened, when connections are released to the pool, etc. jdbc.debug Setting this to true gives you some very verbose information when jdbc calls are made. This information is not as useful as the one for datasource.verbose. jdbc.nontx.autocommitCan be used to set whether autocommit should be on for non-transaction connections. Specify false to turn it off, normally it is on. jdbc.connection.debugIf you are having trouble with leaking jdbc connections, set this to true to find out where the leaked connection was created. debug.jdbc.check Set this to true to perform additional tests when using jdbc.debug=true. Koster, K.J. [EMAIL PROTECTED] wrote: Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life. _ Do You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
RE: Tracing SQL
Thanks, I've downloaded it and will try it later. Kees Jan You are only young once, but you can stay immature all your life. -Original Message- From: Marcel Schutte [mailto:[EMAIL PROTECTED]] Sent: woensdag 30 mei 2001 9:00 To: Orion-Interest Subject: RE: Tracing SQL You can find the jdbc logger at http://marcel.schutte.com/DriverWrapper.zip. It is certainly not a finished product, just some classes to get you on your way. Unzip in orion/lib. In data-sources.xml you have to use nl.gx.common.jcbc.DriverWrapper instead of your original database driver. Hope this helps, Marcel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 12:22 AM To: Orion-Interest Subject: Re: Tracing SQL That's right, I've got it at my daytime (work) PC. Look into it tomorrow morning (GMT+1). Right now I'm enjoying some winamp plugins and wine. Marcel - Original Message - From: Jeff Schnitzer [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:31 PM Subject: RE: Tracing SQL I don't believe there is any way to force Orion to spit out that information. However, when running against Hypersonic in server mode, you see all the SQL on the database console. I find this to be an excellent arrangement for development. If you wanted to, you could fairly easily write a JDBC wrapper that prints the SQL. I wouldn't be surprised if someone has already written such a creature. Jeff -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:03 PM To: Orion-Interest Subject: Tracing SQL Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life.
RE: Tracing SQL
I downloaded and tried it, but I met the following error message, Error initializing server: DriverManagerDataSource driver 'nl.gx.common.jcbc.DriverWrapper' not found As I know, we don't have to do anything to include it in the classpath as long as it is located in c:/orion/lib, where c:/orion is orion home directory. Anyway, I included it in the classpath but the same error message came up. How can I fix the problem? BTW, the jdbc logger can be used against Oracle database? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 5:00 PM To: Orion-Interest Subject: RE: Tracing SQL You can find the jdbc logger at http://marcel.schutte.com/DriverWrapper.zip. It is certainly not a finished product, just some classes to get you on your way. Unzip in orion/lib. In data-sources.xml you have to use nl.gx.common.jcbc.DriverWrapper instead of your original database driver. Hope this helps, Marcel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 12:22 AM To: Orion-Interest Subject: Re: Tracing SQL That's right, I've got it at my daytime (work) PC. Look into it tomorrow morning (GMT+1). Right now I'm enjoying some winamp plugins and wine. Marcel - Original Message - From: Jeff Schnitzer [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:31 PM Subject: RE: Tracing SQL I don't believe there is any way to force Orion to spit out that information. However, when running against Hypersonic in server mode, you see all the SQL on the database console. I find this to be an excellent arrangement for development. If you wanted to, you could fairly easily write a JDBC wrapper that prints the SQL. I wouldn't be surprised if someone has already written such a creature. Jeff -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:03 PM To: Orion-Interest Subject: Tracing SQL Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life.
RE: Tracing SQL
I downloaded and tried it, but I met the following error message, Error initializing server: DriverManagerDataSource driver 'nl.gx.common.jcbc.DriverWrapper' not found As I know, we don't have to do anything to include it in the classpath as long as it is located in c:/orion/lib, where c:/orion is orion home directory. Anyway, I included it in the classpath but the same error message came up. How can I fix the problem? BTW, the jdbc logger can be used against Oracle database? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 5:00 PM To: Orion-Interest Subject: RE: Tracing SQL You can find the jdbc logger at http://marcel.schutte.com/DriverWrapper.zip. It is certainly not a finished product, just some classes to get you on your way. Unzip in orion/lib. In data-sources.xml you have to use nl.gx.common.jcbc.DriverWrapper instead of your original database driver. Hope this helps, Marcel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marcel Schutte Sent: Wednesday, May 30, 2001 12:22 AM To: Orion-Interest Subject: Re: Tracing SQL That's right, I've got it at my daytime (work) PC. Look into it tomorrow morning (GMT+1). Right now I'm enjoying some winamp plugins and wine. Marcel - Original Message - From: Jeff Schnitzer [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:31 PM Subject: RE: Tracing SQL I don't believe there is any way to force Orion to spit out that information. However, when running against Hypersonic in server mode, you see all the SQL on the database console. I find this to be an excellent arrangement for development. If you wanted to, you could fairly easily write a JDBC wrapper that prints the SQL. I wouldn't be surprised if someone has already written such a creature. Jeff -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:03 PM To: Orion-Interest Subject: Tracing SQL Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life.
RE: Tracing SQL
I don't believe there is any way to force Orion to spit out that information. However, when running against Hypersonic in server mode, you see all the SQL on the database console. I find this to be an excellent arrangement for development. If you wanted to, you could fairly easily write a JDBC wrapper that prints the SQL. I wouldn't be surprised if someone has already written such a creature. Jeff -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:03 PM To: Orion-Interest Subject: Tracing SQL Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life.
Re: Tracing SQL
Here is the JDBC debugging calls for Orion... just put them in your orion start statement using -D... for example "java -Ddatasource.verbose -Djdbc.debug -jar orion.jar" Property name Description datasource.verbose Setting this to true gives you verbose info on datasource-creation. When a new datasource is created (at startup) it will print something like this to the console: "jdbc:HypersonicSQL:defaultdb: Started" or "Orion Pooled jdbc:oracle:thin:@test.foo.com:1521:oracle8i: Started". You will also be notified when connections are opened, when connections are released to the pool, etc. jdbc.debug Setting this to true gives you some very verbose information when jdbc calls are made. This information is not as useful as the one for datasource.verbose. jdbc.nontx.autocommit Can be used to set whether autocommit should be on for non-transaction connections. Specify false to turn it off, normally it is on. jdbc.connection.debug If you are having trouble with leaking jdbc connections, set this to true to find out where the leaked connection was created. debug.jdbc.check Set this to true to perform additional tests when using jdbc.debug="true". "Koster, K.J." [EMAIL PROTECTED] wrote: Dear All,I'm having some trouble finding what Orion is doing in my databases. I gettruncated data without any error messages.How can I see what SQL statements Orion executes? (MySQL, with the mm-mysqldriver, if that matters).When I have a Java long datatype for a CMP property on an enity bean. It'smapped to int(11) in the database. How come the values are truncated? Who isclipping my longs?Kees JanYou are only young once,but you can stay immature all your life.Do You Yahoo!? Yahoo! Auctions $2 Million Sweepstakes - Got something to sell?
Re: Tracing SQL
That's right, I've got it at my daytime (work) PC. Look into it tomorrow morning (GMT+1). Right now I'm enjoying some winamp plugins and wine. Marcel - Original Message - From: Jeff Schnitzer [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:31 PM Subject: RE: Tracing SQL I don't believe there is any way to force Orion to spit out that information. However, when running against Hypersonic in server mode, you see all the SQL on the database console. I find this to be an excellent arrangement for development. If you wanted to, you could fairly easily write a JDBC wrapper that prints the SQL. I wouldn't be surprised if someone has already written such a creature. Jeff -Original Message- From: Koster, K.J. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:03 PM To: Orion-Interest Subject: Tracing SQL Dear All, I'm having some trouble finding what Orion is doing in my databases. I get truncated data without any error messages. How can I see what SQL statements Orion executes? (MySQL, with the mm-mysql driver, if that matters). When I have a Java long datatype for a CMP property on an enity bean. It's mapped to int(11) in the database. How come the values are truncated? Who is clipping my longs? Kees Jan You are only young once, but you can stay immature all your life.