Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?  Re: DBD::JDBC craziness
by basiliscos (Monk) on Apr 05, 2014 at 11:46 UTC
( #1081235=note: print w/ replies, xml ) Need Help??  in reply
to DBD::JDBC craziness  I can advice you just to check whether
the required methods work in pure java, i.e. write an simple
java cli-app, that checks available tables and databases. Here
is a small snapshots of java-code, that queries for DB-meta
information using JDBC.  import java.sql.Connection; import
javax.sql.DataSource; import
org.apache.commons.dbcp.BasicDataSource; private static
DataSource getDataSource(){ String login = "root", pwd = "kne";
String url = "jdbc:mysql://localhost:3306/test"; BasicDataSource
ds = new BasicDataSource();
ds.setDriverClassName("com.mysql.jdbc.Driver");
ds.setUsername(login); ds.setPassword(pwd); ds.setUrl(url);
return ds; } private static Object show(ResultSet rs, String
title) throws Exce +ption{ Object r = null;
System.out.println("[s