&gt; For Oracle 9i onwards you should use oracle.jdbc.OracleDriver rather than oracle.jdbc.driver.OracleDriver as Oracle have stated that oracle.jdbc.driver.OracleDriver is deprecated and support for this driver class will be discontinued in the next major release.

-- [http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html#Oracle_8i,_9i_&amp;_10g][1]


  [1]: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html#Oracle_8i,_9i_&amp;_10g

I&#39;m having a tough time getting this to work. I have a string like:

    something/([0-9])/([a-z])

And I need regex or a method of getting each match between the parentheses and return an array of matches like:

    [
      [0-9],
      [a-z]
    ]

The regex I&#39;m using is `/$(.+)$/` which does seem to match the right thing **if** there is only **one** set of parenthesis.

How can I get an array like above using any RegExp method in JavaScript? I need to return just that array because the _returned_ items in the array will be looped through to create a URL routing scheme.

RegEx to match stuff between parentheses

suppose I have the following datastructure:

    var user = {_id: &#39;foo&#39;, age: 35};
    var post = {_id: &#39;...&#39;, author: {$ref: user, $id: &#39;foo&#39;},...};

How can I query all posts which references user[foo]? I tried the following but not work:

    db.post.find(&#39;author._id&#39;: &#39;foo&#39;);
    var u = db.user.find({_id: &#39;foo&#39;});
    db.post.find(&#39;author&#39;: u);

neither can I find the answer from the official document and google!

Anyone has any idea?

How to query mongodb with DBRef

I&#39;m using Oracle&#39;s `ojdbc5.jar` and noticed that it includes two JDBC driver classes.

What is the difference between `oracle.jdbc.driver.OracleDriver` vs. `oracle.jdbc.OracleDriver`?

Which one should I use in my Java project?

Difference between Oracle jdbc driver classes?

I'm using Oracle's <code>ojdbc5.jar</code> and noticed that it includes two JDBC driver classes.
What is the difference between <code>oracle.jdbc.driver.OracleDriver</code> vs. <code>oracle.jdbc.OracleDriver</code>?
Which one should I use in my Java project?

I&#39;m looking for a clean and efficient method of declaring multiple variables of the same type and of the same value. Right now I have:

    String one = &quot;&quot;, two = &quot;&quot;, three = &quot;&quot; etc...

But I&#39;m looking for something like:

    String one,two,three = &quot;&quot;

Is this something that is possible to do in java? Keeping efficiency in mind.

Initializing multiple variables to the same value in Java

    String s1 = &quot;Project&quot;;
    String s2 = &quot;Sunject&quot;;

I want to compare the two above string by their alphabetic order (which in this case &quot;Project&quot; then &quot;Sunject&quot; as &quot;P&quot; comes before &quot;S&quot;).
Does anyone know how to do that in Java?

Comparing strings by their alphabetical order

Why does GSON use **ONLY** fields(private,public,protected)?
Is there a way to tell GSON to use only getters and setters?



Why does GSON use fields and not getters/setters?

I&#39;m running a webapp in Spring Web MVC 3.0 and I have a number of controller methods whose signatures are roughly as follows:

    @RequestMapping(value = &quot;/{level1}/{level2}/foo&quot;, method = RequestMethod.POST)
    public ModelAndView createFoo(@PathVariable long level1,
            @PathVariable long level2,
            @RequestParam(&quot;foo_name&quot;) String fooname,
            @RequestParam(value = &quot;description&quot;, required = false) String description);


I&#39;d like to add some validation - for example, `description` should be limited to a certain length or `fooname` should only contain certain characters. If this validation fails, I want to return a message to the user rather than just throw some unchecked exception (which would happen anyway if I let the data percolate down to the DAO layer). I&#39;m aware of JSR303 but have not worked with it and don&#39;t quite understand how to apply it in a Spring context.

From what I understand, another option would be to bind the `@RequestBody` to an entire domain object and add validation constraints there, but currently my code is set up to accept individual parameters as shown above.

What is the most straightforward way to apply validation to input parameters using this approach?

Spring Web MVC - validate individual request params

This is what I can do in JUnit:

    import org.junit.*;
    @Ignore
    public class FooTest {
      //
    }

and the entire class will be ignored. How can I do the same in TestNG?

How to disable entire unit test in TestNG?

Suppose I have a column name `OrderNo` with value `AO025631` in a table `shipment`.

I am trying to query the table so that I can get only first two character of column value i.e. `AO`.

Can I do this in the SQL query itself?   


How to get first two characters of a string in oracle query?

I want to check SID and current database name.

I am using following query for checking oracle SID

    select instance from v$thread;

but table or view does not exist error is coming.

I am using following query for checking current database name

    select name from v$database;

but table or view does not exist error is coming.

Any idea for above two problems?






Checking oracle sid and database name

If you execute this query

    SELECT &#39;test-a1&#39; AS name1, &#39;test-a2&#39; AS name2
the result will be a one row-selection with two columns having these values: 

    test-a1, test-a2

How can I modify the above query to have a selection with several rows, e.g.

    test-a1, test-a2
    test-b1, test-b2
    test-c1, test-c2

I know how to do this with UNION but I feel that there exists a more simple way to do it.

PS. Sorry for such a basic question, it is very hard to google it.

How to select several hardcoded SQL rows?

How do I add a simple check before adding a column to a table for an oracle db? I&#39;ve included the SQL that I&#39;m using to add the column.

    ALTER TABLE db.tablename 
      ADD columnname NVARCHAR2(30);



How to check if a column exists before adding it to an existing table in PL/SQL?

How would I go about creating a database from a dump file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables, and so on. 

I placed the dump and log file in E: drive

I have tried the import utility 

    E:/&gt;impdp system/tiger@oratest FILE=WB_PROD_FULL_20MAY11.dmp

But I&#39;m getting error as

    invalid argument value
    bad dump file specification
    unable to open dump file &quot;E:\app\admin\oratest\dpdump\WB_PROD_F
    ULL_20MAY11.dmp&quot; for read
    unable to open file
    unable to open file
    (OS 2) The system cannot find the file specified.

And when I see in Windows Explorer DMP file(taken from Linux server) is showing as Crash dump file

I don&#39;t understand how I can resolve this issue. Please help me to solve this issue.

I&#39;m a complete newbie on Oracle... 




How to import an Oracle database from dmp file and log file?

I&#39;m storing two dates in the PostgreSQL database. First, is the data of visit of a webpage, and the second date is the date of last modification of the webpage(this is get as a long).

I have some doubts what is the best strategy to store these values.

I only need day/month/year and hour:seconds and this will only for statistical proposes.

So, some doubts: 

 - is best store as long and convert on recover of information or store in the data format above?
 - is best set the date of visit on the software or in the insertion in the database?
 - in Java, how are the best classes to handle dates? 

What is the most recommended way to store time in PostgreSQL using Java?

So far, I have not found a clear answer to this. 

I&#39;d like to know what the equivalent is for a SQL type DATETIME and the java type, using a PreparedStatement.

I have found: http://www.java2s.com/Code/Java/Database-SQL-JDBC/StandardSQLDataTypeswithTheirJavaEquivalents.htm

But it states that SQL type &quot;DATETIME&quot; is the same as sql.date, but when looking at the SQL date docs (http://download.oracle.com/javase/7/docs/api/java/sql/Date.html), it says the time is truncated (all zeros).

What I want is to be able to specify a `preparedStatement.setDateTime()` or some sort.

The only other way I see is using a timestamp, but that would require me to change the column type, while I cannot imagine someone else never had this problem before?

Any hints?

Edit: I am using MYSQL.

A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)

I&#39;m trying to connect to the local MySQL server but I keep getting an error.

Here is the code.

    public class Connect {

        public static void main(String[] args) {
            Connection conn = null;

            try {
                String userName = &quot;myUsername&quot;;
                String password = &quot;myPassword&quot;;

                String url = &quot;jdbc:mysql://localhost:3306/myDatabaseName&quot;;
                Class.forName(&quot;com.mysql.jdbc.Driver&quot;).newInstance();
                conn = DriverManager.getConnection(url, userName, password);
                System.out.println(&quot;Database connection established&quot;);
            } catch (Exception e) {
                System.err.println(&quot;Cannot connect to database server&quot;);
                System.err.println(e.getMessage());
                e.printStackTrace();
            } finally {
                if (conn != null) {
                    try {
                        conn.close();
                        System.out.println(&quot;Database Connection Terminated&quot;);
                    } catch (Exception e) {}
                }
            }
        }
    }


and the errors :

    Cannot connect to database server
    Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
            at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
            at com.mysql.jdbc.MysqlIO.&lt;init&gt;(MysqlIO.java:344)
            at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2333)
            at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)
            at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
            at com.mysql.jdbc.ConnectionImpl.&lt;init&gt;(ConnectionImpl.java:792)
            at com.mysql.jdbc.JDBC4Connection.&lt;init&gt;(JDBC4Connection.java:47)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
            at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
            at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
            at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
            at java.sql.DriverManager.getConnection(DriverManager.java:582)
            at java.sql.DriverManager.getConnection(DriverManager.java:185)
            at Connect.main(Connect.java:16)
        Caused by: java.net.ConnectException: Connection refused
            at java.net.PlainSocketImpl.socketConnect(Native Method)
            at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
            at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
            at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
            at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
            at java.net.Socket.connect(Socket.java:529)
            at java.net.Socket.connect(Socket.java:478)
            at java.net.Socket.&lt;init&gt;(Socket.java:375)
            at java.net.Socket.&lt;init&gt;(Socket.java:218)
            at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)
            at com.mysql.jdbc.MysqlIO.&lt;init&gt;(MysqlIO.java:294)
            ... 15 more

I&#39;ve set the classpath, made sure my.cnf had the skip network option commented out. 

java version is 1.2.0_26 (64 bit)
mysql 5.5.14
mysql connector 5.1.17

I made sure that the user had access to my database.

Solving a &quot;communications link failure&quot; with JDBC and MySQL

I&#39;m querying a DB using MS SQL and for some reason I get the following error: `com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near &#39;@P0&#39;` even though this &#39;P0&#39; isn&#39;t anywhere in my syntax...

I&#39;ve read that someone has had a same issue but they were using a stored proc, something which I am not using so I don&#39;t see how his solution will work for me. (His solution being asomething about adding braces {} around the procedure call.

Anyways, below I have pasted the relevant code. Really hope someone can help me with this, getting quite frustrated.

  
    PreparedStatement stmt = null;
    Connection conn = null;    

    String sqlQuery = &quot;SELECT TOP ? \n&quot;+
                                  &quot;z.bankAccountNo, \n&quot;+
                                  &quot;z.statementNo, \n&quot;+
                                  &quot;z.transactionDate, \n&quot;+
                                  &quot;z.description, \n&quot;+
                                  &quot;z.amount, \n&quot;+
                                  &quot;z.guid \n&quot;+
                                  &quot;FROM \n&quot;+
                                  &quot;( \n&quot;+
                                  &quot;select  \n&quot;+
                                  &quot;ROW_NUMBER() OVER (ORDER BY x.transactionDate, x.statementNo) AS RowNumber, \n&quot;+
                                  &quot;x.transactionDate, \n&quot;+
                                  &quot;x.statementNo, \n&quot;+
                                  &quot;x.description, \n&quot;+
                                  &quot;x.amount, \n&quot;+
                                  &quot;x.bankAccountNo, \n&quot;+
                                  &quot;x.guid \n&quot;+
                                  &quot;FROM \n&quot;+
                                  &quot;( \n&quot;+
                                  &quot;SELECT  \n&quot;+
                                  &quot;a.bankAccountNo,  \n&quot;+
                                  &quot;a.statementNo,  \n&quot;+
                                  &quot;a.transactionDate, \n&quot;+
                                  &quot;a.description,  \n&quot;+
                                  &quot;a.amount,  \n&quot;+
                                  &quot;a.guid  \n&quot;+
                                  &quot;FROM BankTransactions as a  \n&quot;+
                                  &quot;LEFT OUTER JOIN BankTransactionCategories as b  \n&quot;+
                                  &quot;ON a.category = b.categoryCode  \n&quot;+
                                  &quot;WHERE b.categoryCode is null \n&quot;+
                                  &quot;) as x \n&quot;+
                                  &quot;) as z \n&quot;+
                                  &quot;WHERE (z.RowNumber &gt;= ?)&quot;;

    stmt = conn.prepareStatement(sqlQuery);
    stmt.setInt(1, RowCountToDisplay);
    stmt.setInt(2, StartIndex);
    ResultSet rs = null;
    try{
        rs = stmt.executeQuery();
    } catch (Exception Error){
        System.out.println(&quot;Error: &quot;+Error);
    }

Thanks in advance!

MS SQL Exception: Incorrect syntax near &#39;@P0&#39;

Imagine I have a query like 

    SELECT * from table1 a, table2 b where (WHATEVER)

Maybe both tables have the same column name. So I though it would be nice to access the data via

    resultSet.getString(&quot;a.columnName&quot;);
    resultSet.getString(&quot;b.columnName&quot;);

But this backfires on me and I get nothing. I read the API, but they don&#39;t really talk about this case. Is such a feature vendor dependent?


Content Type	Original Author	Original Content on Stackoverflow
Question	bw_üezi	View Question on Stackoverflow
Solution 1 - Java	Asaph	View Answer on Stackoverflow

Difference between Oracle jdbc driver classes?

Java Problem Overview

Java Solutions

Solution 1 - Java

How to query mongodb with DBRef

RegEx to match stuff between parentheses

Attributions