Re: MySQL + JDBC

2009-12-15 Thread Todd Grigsby
...@tgrigsby.com] Sent: Monday, December 14, 2009 9:57 PM To: Struts Users Mailing List Subject: Re: MySQL + JDBC Not that I wanted to get into a debate about the usefulness of ODBC, but the Java-based web services we have aren't the only things that connect to these databases, and going through ODBC has

Re: MySQL + JDBC

2009-12-15 Thread Gabriel Belingueres
[mailto:strutsu...@tgrigsby.com] Sent: Monday, December 14, 2009 9:57 PM To: Struts Users Mailing List Subject: Re: MySQL + JDBC Not that I wanted to get into a debate about the usefulness of ODBC, but the Java-based web services we have aren't the only things that connect

Re: MySQL + JDBC

2009-12-15 Thread Patrick J Kobly
Do you have other Java apps working, or just other native apps? PK Todd Grigsby wrote: It's all 64-bit, installed correctly enough to work from other apps. I will try the Sun forums. TG - To unsubscribe, e-mail:

Re: MySQL + JDBC

2009-12-15 Thread Todd Grigsby
Other native apps. The Java apps are being migrated from a 32-bit environment (WinXP and Java 32-bit + Struts 1.1), and they worked there. I don't want to point to any one thing, since every part of the equation is a newer version of what was there before, but at this point the only

Re: MySQL + JDBC

2009-12-15 Thread Patrick J Kobly
Todd Grigsby wrote: Other native apps. The Java apps are being migrated from a 32-bit environment (WinXP and Java 32-bit + Struts 1.1), and they worked there. I don't want to point to any one thing, since every part of the equation is a newer version of what was there before, but at this

Re: MySQL + JDBC

2009-12-15 Thread Todd Grigsby
Patrick J Kobly wrote: Todd Grigsby wrote: Other native apps. The Java apps are being migrated from a 32-bit environment (WinXP and Java 32-bit + Struts 1.1), and they worked there. I don't want to point to any one thing, since every part of the equation is a newer version of what was

Re: MySQL + JDBC

2009-12-15 Thread Patrick J Kobly
Running the binary dist of Tomcat? tomcat.exe / tomcatw.exe PK Todd Grigsby wrote: Patrick J Kobly wrote: Todd Grigsby wrote: Other native apps. The Java apps are being migrated from a 32-bit environment (WinXP and Java 32-bit + Struts 1.1), and they worked there. I don't want to point

Re: MySQL + JDBC

2009-12-15 Thread Todd Grigsby
Yes. Running Tomcat 6 as a Windows service...Ok, this is interesting. On a whim, I ran tomcat6w, and when it came up, it appears to using the C:\Program Files (x86)\Java\jre6\bin\client\jvm.dll, which implies to me that the JVM it's attempting to use is the 32-bit version. High

Re: MySQL + JDBC

2009-12-14 Thread Todd Grigsby
Fantastic! The error that I'm getting is, org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application. Ever seen that? TG Neil Aggarwal

Re: MySQL + JDBC

2009-12-14 Thread Todd Grigsby
Oh, and a relevant follow-up question: do you use JDBC-ODBC to connect to MySQL? TG Neil Aggarwal wrote: Let me simplify the question: Has anyone out there managed to create a working connection to the latest version of MySQL 64-bit via JDBC from Struts 2? I am sure many people

Re: MySQL + JDBC

2009-12-14 Thread Manos Batsis
Todd Grigsby wrote: Fantastic! The error that I'm getting is, org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application. Ever seen that?

Re: MySQL + JDBC

2009-12-14 Thread Todd Grigsby
Manos Batsis wrote: Todd Grigsby wrote: Fantastic! The error that I'm getting is, org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory ([Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and

Re: MySQL + JDBC

2009-12-14 Thread Gabriel Belingueres
What do you mean by I need to use ODBC to abstract the database connection.?? In most (all?) web containers I know about, there is a standard way of abstract out the database connection and it is by declaring a javax.sql.DataSource, which you can get it from JNDI (which is pretty standard too.)

RE: MySQL + JDBC

2009-12-14 Thread Neil Aggarwal
Oh, and a relevant follow-up question: do you use JDBC-ODBC to connect to MySQL? I never used ODBC to talk to MySQL. I am not sure how well that would work. Thanks, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net Host your MySQL database on a CentOS virtual server

Re: MySQL + JDBC

2009-12-14 Thread Todd Grigsby
Works great, Neil, thanks for asking. TG Neil Aggarwal wrote: Oh, and a relevant follow-up question: do you use JDBC-ODBC to connect to MySQL? I never used ODBC to talk to MySQL. I am not sure how well that would work. Thanks, Neil -- Neil Aggarwal, (281)846-8957,

Re: MySQL + JDBC

2009-12-14 Thread Todd Grigsby
Not that I wanted to get into a debate about the usefulness of ODBC, but the Java-based web services we have aren't the only things that connect to these databases, and going through ODBC has been, for the last 10 years, a very nice and consistent way to connect across all our applications

RE: MySQL + JDBC

2009-12-14 Thread Lee Clemens
- From: Todd Grigsby [mailto:strutsu...@tgrigsby.com] Sent: Monday, December 14, 2009 9:57 PM To: Struts Users Mailing List Subject: Re: MySQL + JDBC Not that I wanted to get into a debate about the usefulness of ODBC, but the Java-based web services we have aren't the only things that connect

Re: MySQL + JDBC

2009-12-14 Thread Todd Grigsby
message/condition do you receive? Or are you merely asking if MySQL 64-bit is compatible with ODBC [OT]? -Original Message- From: Todd Grigsby [mailto:strutsu...@tgrigsby.com] Sent: Monday, December 14, 2009 9:57 PM To: Struts Users Mailing List Subject: Re: MySQL + JDBC Not that I

Re: MySQL + JDBC

2009-12-14 Thread Nils-Helge Garli Hegvik
]? -Original Message- From: Todd Grigsby [mailto:strutsu...@tgrigsby.com] Sent: Monday, December 14, 2009 9:57 PM To: Struts Users Mailing List Subject: Re: MySQL + JDBC Not that I wanted to get into a debate about the usefulness of ODBC, but the Java-based web services we have aren't the only

MySQL + JDBC

2009-12-13 Thread Todd Grigsby
Let me simplify the question: Has anyone out there managed to create a working connection to the latest version of MySQL 64-bit via JDBC from Struts 2? TG - To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For

RE: MySQL + JDBC

2009-12-13 Thread Neil Aggarwal
Let me simplify the question: Has anyone out there managed to create a working connection to the latest version of MySQL 64-bit via JDBC from Struts 2? I am sure many people have. I run 64 bit servers with MySQL and Struts 2. What are you seeing? Neil -- Neil Aggarwal, (281)846-8957,